Sales Reports

The Credit Register lets you choose to include credits lines that have negative quantities, or all lines on a Type C order, or a combination of those definitions. Because a pricing adjustment is of entered as a credit plus a debit, defining a credit as any line on a Type C order shows the net credit or the difference between the wrong price and the right price.

Enter option 2 - Credit Registers. The Credit Register Parameter Selection screen appears.
On the next two screens you can choose a company and sorting options for the report.
Complete the fields on these screens, as necessary, and press Enter. The Credit Line Inclusion screen appears. Enter one of the following options:

Option 1 - Shows all lines on an invoice that is coded as a credit with order type C. When the invoice is associated with an order that has credit type C in the header, both the Credit and Debit Lines are included on the Credit Register, and the Invoice Sub Total line reflects the net credit.
Option 2 - Shows lines that have a negative quantity.
Option 3 - Shows lines that have negative quantities and all lines with order types codes of C.

If you select either option 1 or 3, the next screen gives you the option to include or exclude debit lines.

4. Select one of the following options:

Option 1 - to show any debit on a type C invoice, regardless of the credit code field.
Option 2 - to include only lines that have a credit code. A credit code appears as the result of price adjustments.

Miscellaneous F6 Line Sales (RSA 5)

The Miscellaneous (F6) Line Sales Report can be sorted and sub-totaled by

branch
warehouse
cost center
cost center/branch
cost center/warehouse
truck route
customer account

These sort and sub-total options are becoming increasingly important as transaction based fees are implemented. For example, if you assign general ledger account numbers and/ or cost centers to delivery charges, packing charges, and such, then this report can analyze those charges by customer, branch, truck route, and so on, using the available sort and sub-total options.

Sales Tax Reports (RSA 6)

This is the main sales tax report, usually run at the end of a month or period, for reporting how much tax was charged.

This report only lists invoices with tax codes on the header of the invoice. Non-taxable invoices will not be listed so that the NET(A/R) and NON-TAX column totals will not reconcile to total sales for the period. We suggest using RSA 21 for tax filing purposes. Also, RSA 6 will not recognize tax exempt items.

It allows you to choose between billto state and shipto state on all versions. When you request the Sales Tax Report, the following screen displays:

Enter a GP% Span or Blank for all (001-999, + or -) - You can use this field to narrow the report down to a specific gross profit margin.
Enter P for PAID ONLY, U for UNPAID ONLY, or Blank for All - Allows you to include only paid transactions, only unpaid transactions, or both.
Enter Ship Via codes or Leave Blank for ALL Ship Vias - You can use ship via codes as one of the parameters to sort and organize this report. This is useful for retail businesses that use special ship via codes for installs versus non-installs. It can also be used to separate will call versus other ship via methods.
Enter the ship via codes you want to include in the report. Only the codes you enter are included all others are not considered. To include all ship via codes just leave the field blank. This option is important if taxes are applied differently based on ship via codes, such as WILL CALL versus DELIVERY versus INSTALL.

To display a listing of all the available ship via codes, insert a ? in the field and press Enter.

Several screens appear that allow you to customize the report.
You can choose whether to run the report for the state on the billto or the shipto address. When the Sales Tax Report is formatted and sorted, it uses either the state within the billto address or the state within the shipto address. When an invoice does not contain a shipto address, the billto address is assumed as the shipto address.
You are presented with several sorting options. Choose the one that best serves you. For example, the option to use the county from the zip table is recommended for any companies that have set up FIL 43 (Tax by Zip Code Table).
If you want to run the tax report using the current tax rate in the Tax file, use option 1 - Base Calculations on Tax Rates in Current File. However, if you want to run the tax report to see the amount that was collected at the time of invoicing (tax rate could have changed since then) for tax audits then take option 2 - Base Calculations on Tax Rates applied at time of Invoice. When you choose option 2, the tax amounts are shown, but not the tax rate, as the rate could vary within a single sub-total, if the rate was changed during the date span of the report.
You can enter a state code or leave the state field blank to include all states.

Version 5 of the Sales Tax Report sorts by state/county/tax codes. The use of this tax report sort enables you to use the same tax codes for multiple counties, yet still break out taxes and sales by county. For example, tax code A1 could indicate Alabama 10% and can apply to multiple counties. The report can still break on county even through multiple counties are assigned A1.
When the Sales Tax Report is formatted and sorted, it uses either the state within the billto address or the state within the shipto address, as selected above. When an invoice does not contain a shipto address, the billto address is assumed as the shipto address.

Creating a Spreadsheet from the Sales Tax report

This report includes an option to convert the information into an Excel spreadsheet. Furthermore, when the report is converted to a spreadsheet, the invoice header warehouse and shipvias are included. This additional information can help ease the time commitment when filing taxes in various states by identifying specific tax information (e.g. state, city, and county).

These functionality works with all of the report versions, but it was specifically designed for version 5. This version sorts by state/county/tax codes. The use of this tax report sort enables you to use the same tax codes for multiple counties, yet still break out taxes and sales by county. For example, tax code A1 could indicate Alabama 10% and can apply to multiple counties. The report can still break on county even though multiple counties are assigned A1.

Work through the report generation screens until prompted for options on the following screen.

The fields on this screen are described in the following table.

Field	Description
Report Type	Option 1 generates a regular report that gets sent to your spool file where you can print it out as needed. If you choose this option, none of the other fields are required. Option 2 generates a file in a spreadsheet friendly format. You can then choose to print it or email it. Option 3 creates both a spool file and a spreadsheet file.
The following fields are required only if you choose option 2 or 3 to generate a spreadsheet
File Name	Enter the file name. You should attach the suffix .xls to the file name.
Destination Folder	This is the IFS directory where you want the spreadsheet to be placed. Once the spreadsheet is generated and sent to this destination you can retrieve it via the Windows Explorer, if you are mapped to the folder. It can also be accessed via WRKLNK command on the IBM iSeries. You cannot use directory /QDLS. If you do not enter a destination folder, you must enter an email address. If no destination folder is entered, a temporary one is created that is automatically deleted when the email is sent.
EMAIL File to	Enter the email addresses of the person or people you want to receive the report. To access more lines, press the Page Down key. The following guidelines pertain to the email feature: You do not have to assign a directory if you email only, the system will automatically use /home/dancik/reports/temp A Java Kit must be installed on your server (automatically installed via the IBM V5R3 Upgrade). The HTTP Server, TOMCAT and APACHE servers must be running. If you use the ODS system these servers will already be running.

An example spreadsheet is shown below. Notice the two new headings: Header Warehouse and Shipvia.

Daily System Snapshot Analysis (RSA 11)

This report is based on a statistics file that is activated by the Daily Systems Snapshot and Inventory Data Warehouse Options which must be activated by your system administrator.

This report is available for several categories, and with several options. It combines many of your most vital business statistics on a single report.

When this report is selected, the following parameter screens appear.

The screen above displays the four Daily System Snapshot categories, notating which are activated. Only activated options can be selected.

The Daily System Snapshot categories are activated via the system wide setting Daily System Snapshots File Options.

Enter an X next to one of the categories and press Enter then F7 to access screen 2 of the parameter settings.

The parameters at the bottom of the screen will change to reflect the category you are running the report for. For example, if you selected the Manufacturer, the following parameters would appear: Company#, Warehouse and Manufacturer.

The parameters on this screen are described in the table below.

Parameter	Description
Enter Date Span	Enter the span of dates to show individual daily records (snapshots) for. For example, if you enter 30198 to 30798, an individual line is printed for each of those days. The default is the past week.
Enter Accounting Mth Span	Enter the span of accounting months to use for the accumulated totals columns. When analyzing a single month, you should enter the current accounting period in both the from and to fields. The date span entered above should be within the accounting month span entered here. The default is the current accounting month.
Enter # of Days In Current Month To Use For Projections	Enter the number of business days in the month (or months) represented by the Accounting Month Span entered above. This number is used to generate report projections according to the following formula: PROJECTION=AVERAGE DAILY X NUMBER OF DAYS IN PERIOD.
Enter Difference in Days Between Shipping and Invoicing	Enter the number of days, if any, between when an order is physically shipped, and when it is invoiced. If you invoice the next day, enter 1 in this field. This field determines the date appearing in the DATE SHIPPED column of the report.
Include Company #s, Warehouses, and Cost Centers	Enter the companies, warehouses, and other parameters to limit the report to. Leave any parameter blank to include all. The parameters shown on this screen change based on the previous category selection.

Make the necessary entries and press Enter then F7 to continue to the next screen where you will select a report version. Select one of the versions. The system uses the appropriate data (sales, gross profit, or quantity) to generate the report. Press Enter.
On the next screen in the process, select option 1 to list the data without each warehouse being listed in each category code. For example, if you are running the report by Cost Center, option 1 simply shows day by day tables for each cost center. Option 2 shows, for each day, a subtotal for each warehouse, followed by the cost center total including all warehouses. The default option is 1. Also choose option 1, if you are limiting the report to a single warehouse, or have only one warehouse.

Sales Tax Report for Non-Taxed Items - Use Tax (RSA 12)

This feature allows you to run tax accrual reports for some states and items where the tax is calculated on the cost of the item. For example, use this report when samples are sent to customers at no charge or samples are used in your showroom (and billed to an intercompany account at no charge) and there is a tax liability. This is also referred to as Use Tax. This program looks for items that (a) were sold at no charge, (b) have special tax codes in the Item File, and (c) other items that were not charged tax.

This report only includes invoices if they were NOT TAXED, to catch those sales that are not accounted for on the regular Sales Tax Report, and/or were sold at no charge. Invoices/Items are made non-taxable in the following areas:

Billto File
From the F9 - Non-Taxable/Taxable Function Key on the Order Header.
Using special codes on Order Entry Cmd-6 Miscellaneous lines.

The first screen provides you with six options as each customer may need a different variation based on how they use the tax codes, and if they are in Canada or Australia. For example, use option 6 - Include Line Items if Price = Zero to include only those items whose price equals zero. This option only reports those items sold at 100% discount. In general, items with no price are likely to be subject to use taxes based upon costs.

The next screen to appear lets you select report parameters.

Select the applicable parameters or press Enter to include them all. A second parameter screen appears that allows the user to enter the type of items to run the report for.

The item parameter Tax, shown above as parameter number 23, may be used to limit the report to items with specific tax field values in the Item File.

The next series of screen allow you to choose the following:

A company to run the report for
Use the Billto or Shipto state
Report sorting options

The last screen to appear, before actually running the report provides options for calculating tax.

Select option 1 - to Calculate Use Tax only if the Invoice has Tax Codes if you only want to include use tax information for invoices that have tax codes.

If you choose option 2, the system tries to find an applicable tax rate even if the invoice does not have any codes. The system checks the following, in this order, for applicable tax information:

Zip Code Files - This includes the Tax by Zip Codes Table. This table allows you to base taxes upon the shipto destination when the shipto addresses are manually overridden in the Order Entry and Order Change programs. If this table is activated, the system checks here first.
Billto File - Here the system checks the Tax Codes fields. There is a State tax code and an Other tax code. The Other field can be used to enter a local or county tax. In Canada and Australia, Other Tax may be GST, and State Tax may relate to Provincial or Local Taxes. If there are two tax codes the system adds them together for the total tax.
County File - The next check is in the County File. The County File enables you to define each county number used in the Billto File. This file (and/or the Tax by Zip Code File) is required in order to automatically tax customers if they are normally non-taxable customers.
Warehouse - This file is checked as a last resort. The system looks for tax information (state, county, city) from the warehouse where the product was shipped.

Combined Sales and Order Summary Report (RSA 13)

This report provides simple summary reports primarily, for salespeople, including sales, orders taken, and the open order backlog - all on one sheet of paper. Typically this report is run by Company/Salesperson for last month's sales & orders. Each salesperson sees what was sold (invoiced) as well as orders taken (but not necessarily invoiced) and orders still open. For example, if you run by salesperson. the salesperson can see the following all on one report.

their sales for the time period,
their orders taken in that time period, and
their open order backlog

Enter any combination of INV (invoice) Dates, INV#s range, ORD (order) Dates, and ORD#s. You can use the dates and ranges in any combination. However, the defaults of last month's sales & orders taken are the most applicable.

If necessary, use the field Do you want to access 2nd Slmn# on header & split sales? to run the report for multiple salespeople. The Split% field allows both salespeople to get a % of the order or sales on their respective reports.

Use the I/O fields to include or omit parameters. If you include parameters, the report only includes information for the selections you enter. If you omit parameters, the report runs for all parameters except those you enter.

Enter the necessary information and press Enter then F7 to continue to the Sort Screen.

Enter at least two and up to four sort selections, by entering a 1, 2, 3, and 4 next to your choices. To control where the page break occurs, enter a sort level in the Page Break on Sort Level field. If you don't want a page break enter 1, which will only page break on the 1st level which can be company number.

There are only three columns of figures on the report: Sales, Orders Taken, and Open Order Backlog. Each column also includes the respective gross profit percentage. The invoice information gets inserted into the Sales column report and the order information is inserted into the Orders Taken column. The Open Order Backlog column includes all open orders regardless of the date parameters entered.

Note: To run this report for the Open Order Backlog, you do not need to enter a date span, because it includes all open orders.

Deliveries With & Without Delivery Charges (RSA 14)

This report lists each customer's delivery charge, or indicates if delivery is free of charge. It also indicates whether or not the customer is subject to minimum charges, as established in the Minimum Charges File.

This listing provides the ability to quickly see if a customer has delivery charges applied by unit. This feature eliminates the need to pull up each file and check them individually.

The Deliveries With and Without Delivery Charges report enables you to analyze your delivery charges with an emphasis on deliveries that were made without charges.

The first screen is a parameter screen that is similar to the parameters for running Invoice Registers. The Deliveries With and Without Delivery Charges report is similar to an Invoice Register, but it only lists invoices that have been assigned to a truck route.

The next screen controls how the report is sorted.

The default sort option is 1, which groups the invoices in the same way that the invoicing program groups invoices when assigning delivery charges. Within any given route, for a ship date, only one invoice for each customer should contain the delivery charges for that day.

Sorts 1 and 2 enable you to see the invoices arranged as they would be for assigning delivery charges.
Sort 3 enables you to see each customer's deliveries over a specified period of time.
Sort 4 enables you to track deliveries by account on a day-to-day basis, regardless of the truck route codes used.

A sample report is shown below. Please note the following features:

The delivery charges (which are stored on line 9966 of an invoice) are shown in the column Delivery-Charge. They are also included in the MISC column, which includes all miscellaneous charges on an invoice.
The ship date and truck routing codes are shown on the right side of the report, followed by a special code whenever no delivery charge is found.
- *1 means that his customer is coded for free delivery in the Billto File.
- *2 means that line 9966 was keyed by a user for free delivery.
- *3 means that there was no line 9966 found on the invoice.
Sub-totals are shown for each account number regardless of your sort option.
At the bottom of the report, Sales Recap 1 shows the total delivered sales with delivery charges, and the total delivered sales without delivery charges.

Refer to these other reports, which have information regarding truck routes and deliveries: Invoice Register sorted by Truck Route, X by Y Reports sorted by Truck Route, and Shipping Analysis Reports.

When reviewing the Deliveries With and Without Delivery Charges report, remember that even though all of the invoices listed were deliveries (with a truck route code), only one invoice per ship date, per customer, should have a delivery charge.

An * in the DELIVERY CHG$ column denotes the customer is assigned a delivery charge by unit.

Commission Report Based on Price Class (RSA 15)

The Commission Report option allows you to run a commission report based on price classes. This is a self-contained alternate commission system with its own rate table and report. All other sales commission options are included in the X by Y Commission Reports, on menus COM and RSA.

Note: It is recommended that you use only one of the commission reporting methods. The two methods are mutually exclusive.

1. Select option 15 to access the Price Class Commission Maintenance/Reporting screen.

2. The two options on the screen are:

To Update Price Class Commission Table - Lets you configure and maintain the table.
To Report Commissions by Price Class - Lets you run the report by date or invoice range.

Updating the Price Class Commission Table

1. Selecting this option displays the Price Class Commission Rate Maintenance screen. The concept of this commission system is to base commission on the prices charged, based on rates for each product.

2. From this screen you can inquire about, update, delete, or add a commission structure for a price class. To update an entry, enter a U in its Option field and press Enter.

3. Update the entries as needed. In the above example, the following commission structure is in place for items in price class ARMVB6:

For sales with a unit price from $10 to $10.99, the commission rate is 10%.
For sales with a unit price from $11 to $12.99 the commission rate is 12%.
For sales with a unit price from $13 to $14.99 the commission rate is 14%.
For sales with a unit price from $15 to $17 the commission rate is 16%.

Only items that are within price classes that are included in this table are commissioned.

Running the Commissions by Price Class Report

1. Select the second option, To Report Commissions by Price Class, on the Price Class Commission Maintenance/Reporting screen.

2. On the screen that appears, enter either an invoice date range or an invoice range.

If entering invoice dates, enter them as mmddyy.

3. Press Enter and then F7 to continue to the process.

Within each salesperson, the subtotals are by invoice.

Item Sales, Price and Cost Analysis Report (RSA 16)

This report provides a convenient method to see the relation between item sales, what you are making off those sales, and what your costs are.

When this option is selected, the Item Selection screen appears. Use this screen to choose items to include in the report.

Make your selections and press Enter, then F7 to continue to the next screen. This screen presents you with several sorting options and options to narrow the report by warehouse or item type.

Enter your options and press Enter then F7 to continue to the next screen.

The options on the above screen are explained in the following table.

Field	Description
Enter a PRICE LIST# to use for the prices that will print	The report uses this price list for pricing information and analysis.
Enter WAREHOUSE to use for Costs and Receipt Dates	Enter a single warehouse for costing information or leave blank to include all warehouses.
Enter 1 for Version 1 (One line printed per item) Enter 2 for Version 2 (Two lines printed per item).	Enter a 1 to only have one line printed per item. Enter a 2 to direct the system to print 2 lines per item.
Omit Items with zero sales this year-to-date & last year-to-date	Enter a Y to omit those items that have not had any sales so far this year or all of last year.
Enter 1 to show Year-To-Date versus Last-Year-To-Date sales, or Enter 2 to show Past 12 Mths versus Previous 12 Mths sales	Use these options to customize the report to show the information you want to see. You can see either a comparison of year-to-date sales or a comparison of sales based on a 12 month span.

Enter your options and press Enter then F7 to continue to the next screen to choose a unit of measure you want the items to be in on the report.

Job Work-In-Progress Report (WIP) (RSA 17)

This report tracks actual billing and costs against estimated billing and costs. It does this by comparing order dollar amounts against invoiced dollar amounts for the same order or time span.

This report works in conjunction with the Job Estimates and WIP Reporting screen. This screen is accessed, if permission is given, via the F2 function in Order Entry or Order Change.

When option 17 is selected, the following parameter selection screen appears.

Enter the necessary information and press Enter, then F7 to continue to the Sort Screen.

The report includes totals for all regular line items on the orders. This includes, but is not limited to, material, labor, freight, use taxes, etc. Anything that is placed as a line item on the order is reflected on the report.

Out of State Sales Report (RSA 18)

This report is designed to list invoices where tax issues may need to be verified or resolved. Invoices are listed regardless if they were charged any tax. The user picks a main sort, and the sub-sort is by tax codes.

This report looks for the following exceptional situations:

Will-Calls that are for customers whose billto state is different than the state of the warehouse where goods were will-called.
Shipments and Deliveries that are for customers whose billto state is different than the shipto state of the invoice.

An example report is shown below:

Under the customer name is an explanation of why each invoice appears on this report. The first invoice was a North Carolina account that will-called at the New York warehouse. The last invoice shown was a shipment from North Carolina to North Carolina, but for a Maryland customer.

Four-Way Sales and GP Analysis (RSA 19)

The Four-Way Sales and GP Analysis provides a simple alternative to X by Y reports. The following information for each sort category is included on the report:

Gross Sales
Gross Profit Dollars
Gross Profit %
Quantity and UM

This report enables you to include or omit data based on several parameters and then sort with up to 4 levels of sub-totals. This allows you to design hundreds of reports with up to 4 levels of sorting and subtotals.

Select option 19 on the Sales Reports Menu (RSA) and enter an invoice date range and/or an invoice number range.

This report adheres to the Business Entity functionality. Business Entities are any combination of companies, branches, and cost centers. Business Entities are assigned to users through the users control panel (CTRLUSER (SET 2) program). If a user is assigned to a Business Entity, it will appear in the Business Entity field.

If the you are running the report by salesperson, and you use the secondary salesperson feature, enter a Y in the Do you want to access 2nd Slmn# on header & split sales and the split amount in the Split% field.

Secondary salespeople are assigned on the Order Header screen. There is a Primary Salesperson field, and a Secondary Salesperson field, located under the Primary Salesperson field.

Select the parameters that you want to include in the report and press F7, then Enter to proceed to the Sort Selection screen. You can enter up to 4 sort options by entering 1 - 4 next to the fields of your choice. Each sort field represents a level of sub-totaling. You must enter at least two selections by entering 1 or 2. Enter only as many as you require.

You can specify where your page break should occur. The default page break is on your primary sort (sort 1).
If a C is entered into the For Crossover Items, Use Parent or Child Item#/Name field for child the crossover item appears on the inquiry screens and sales reporting documents.
The setting For Crossover Items, Include Child Items Only allows you to analyze private label business, where the crossover feature is used to create child items that are linked to parent items. The parent items are the actual items with inventory. The child items have different item numbers and descriptions, but access the same inventory. Activating this setting directs the report to show only the sales that were made using the child item numbers. Normally the terms private label item, crossover item and child item are synonymous.

The Crossover System, located in the Item File (FIL 2), to assign two or more item numbers to the same inventory item. The two items have the same inventory, but can have different item numbers and different descriptions. The item containing the inventory is known as the parent item. The dependent items are known as child/crossover items. You can use this system to market the same product under multiple numbers and names. For example, two different customers can have exclusive sales rights to the same item. Both customers can place orders under their own assigned item numbers and descriptions, and receive all documents (pick lists, invoices, bar code labels) with their assigned item numbers and descriptions, even though the actual inventory is the same.

The Four-Way Sales and GP Analysis Report was designed to take advantage of having four sort levels. You can run reports that were not possible with the two sort levels of the X by Y reports.

Some examples are:

Sales force analysis
- Sort 1 = Sales Territory or Region
- Sort 2 = Sales Manager
- Sort 3 = Salesperson
- Sort 4 = Customer
Item Class Analysis
- Sort 1 = Cost Center
- Sort 2 = Item Class 1
- Sort 3 = Item Class 2
- Sort 4 = Item Class 3
Customer Analysis
- Sort 1 = Branch
- Sort 2 = Customer Type
- Sort 3 = Chain/Account
- Sort 4 = Cost Center
Supplier Product Analysis
- Sort 1 = Usual Supplier
- Sort 2 = Manufacturer
- Sort 3 = Product Line
- Sort 4 = Item Number

Four-Way Order Contact Analysis (RSA 20)

The Four-Way Order Contact Analysis report shows the customer contact information entered during Order Entry. It displays the contact information of the person that placed the order. This report is designed to capture sales information based on the order contact, for the purpose of calculating spiffs or commissions for these contacts.

Order contact is entered on the Order Header during the order entry process. The order contact field is activated by the System Wide Setting Options for Customer Order Contacts.

On the Sales Report Menu (RSA), select option 20 - Four-Way Order Contact Analysis. On the parameter screen that appears, enter an invoice date range and/or an invoice number range. You may include or omit sales based on the selection criteria.
Select the parameters that you want to include in the report and press F7, then Enter to proceed to the Sort Selection screen.
You can enter up to 4 sort options by entering 1 - 4 next to the fields of your choice. Each sort field represents a level of sub-totaling. You must enter at least two selections by entering 1 or 2. Enter only as many as you require.

The program issues a warning if you do not select Order Contacts as one of your sort options.

You may specify which sort level to page break on. The default is to page break on your first sort level.
If you only want to see invoices that include order contact information, enter a Y in the Omit if no Order Contact field.
There is a detail and a summary version. The detail version prints each invoice/line number. The summary version prints the sub-totals you have specified, based on the sort options.
You can choose to display the amounts accrued in a specified cost driver, amounts accrued in a specified cost driver category (such as rebates), or the amounts accrued in fund dollars and points. You must choose one of the three options. This screen defaults to the cost driver number and/or cost driver category entered in the system wide setting Options for Customer Order Contacts.

Strategies for Using the Four-Way Order Contact Analysis Report

Strategy #1 (Recommended)

Use cost drivers to accrue the spiff or commission amount for the order contact. Set up a cost driver which accrues an amount (such as percentage) of sales made to customers in this spiff program. Assign that cost driver number as the default to use for this report, by entering it on the system wide setting Options For Customer Order Contacts.

Strategy #2

Use fund dollars or fund points to accrue the spiff or commission amount for the order contact. Set up funds to accrue this amount. When running this report, select the option to show funds instead of cost drivers.

Strategy #3

Use the report without accruing cost drivers or funds. The amount of the spiff or commission paid will be a manual process based on the report figures.

Sales Tax Report - For Auditing (RSA 21)

This report is similar to the main sales tax report produced through option RSA 6. This report has additional features for auditing.

Select the parameters that you want to include in the report.
Next select a single company to run the report for, or leave the field blank to include all companies.
Choose to run a detailed version (lists each invoice) or a summary version (lists totals for each tax code).
Regardless of the version you print the subsequent screens allow you to make the following decisions:
- Which state to use for reporting; the state within the BILLTO or SHIPTO Address.
- How to sort the report. There are five sorting options that range from sorting by company to county and state.
- Which tax rates to base calculations on; the tax rates in the current file or tax rates applied at time of invoicing.
- Choosing an Auditing option from four options:
  - Include all invoices (taxed or not)
  - Only include invoices with no tax codes
  - Only include invoices with tax codes, but with a zero rate
  - Only include invoices with no tax codes OR a zero rate
- To print the tax codes found in the Tax By Zip file, if there are no tax codes on the invoice.

The main difference between the Summary and Detailed versions is the inclusion of the invoice and customer information.

Four Way Special Order Analysis (RSA 22)

With countless products available from thousands of suppliers around the world it is often difficult to gather meaningful information about your non-stock special order items. These items are often ordered using generic and/or miscellaneous item codes, which make reporting difficult.

This report enables you to analyze sales of special order items. You can sort based on all of the fields that are relevant to special orders including the supplier and the hand-keyed descriptions that are entered along with your generic/miscellaneous item codes.

This report is designed to select only the following items:

special orders (S in the Lot field of the Order Detail screen)
MISC Items (MISC entered in the color field of the Order Detail screen)
items with Policy RD (Requires Description) in any of the three available policy code fields in the Item File.

The unique aspect of this report is that it displays and can sort by the description keyed on the F6 line directly following the special order item. When many items are special ordered using MISC codes, it is very difficult to analyze what is being sold. With this report, you can sort by description within manufacturer, and see what special order items are repeatedly sold.

Another feature of this report is the ability to conduct a string search via the 5 Include only if the following strings are found on message line settings on the Sort Selection screen. These input fields allow you to enter additional search criteria. For example, if you entered Kitchen only the invoices that included Kitchen on an F6 line are included. You could also enter dimensions in several ways such: 12x12, 12 x 12, 12x 12, and 12 x12, to pick up special orders for 12 x 12 tile, regardless of how the user typed it into an F6 line.

The example report shown below is sorted by item number, followed by the special description keyed by the users. One order for item SHAMISC shows the description SHAW SPECIAL ORDERS AS FOLLOWS, indicating that no special description was keyed by the user who entered the order. When the program can not find a special description (keyed on an F6 line of the order), it shows the generic description from the Item File.

Ten-Way Fiscal Sales Analysis (RSA 101)

The Ten-Way Sales Analysis Report is a comparative analysis that compares two fiscal years. The default settings compare This Fiscal Year to Last Fiscal Year.

This report allows you to design hundreds of reports with up to 10 levels of sorting and subtotals.

Enter option 101 to access the Ten-Way Fiscal Sales Analysis Reports. The following screen displays.

The Ten-Way Sales Analysis Report enables you to include or omit data based in several parameters and then to sort with up to 10 levels of sub-totals.

The above screen defaults to a data span representing the beginning date of your prior fiscal year, and ends with today's date. The report includes columns for this year to date and last year to date. The report also includes a column for this month, which is determined by the end date of your span. Therefore, if you want the this month column to be last month, you can change the end date to the last day of last month.

We do not recommend that you alter the from date or the invoice number span unless you are purposely limiting the report. You can limit the report to specific data by entering I in the I/O fields, which represents include or omit, and entering the appropriate field values. However, if you need to override the From date, which is automatically populated with the last fiscal year end date, press F9.

All date range are validated to ensure that fiscal periods are correctly selected. The report defaults to a valid fiscal year-to-date range.

You can omit data by entering O in the I/O fields, and entering the appropriate field values. Press Enter and F7 to continue.

Function keys

Field	Description
F2 - Retrieve Parameters	Retrieves report parameters you have previously saved, and allows you to reuse or modify them. (Whenever you run a Ten-Way report, you have the option to save the report parameters.)
F4 -Cancel	Cancel and return to menu.
F9 - Change Dates	Date Span Enhancements - On the first screen, the from date is populated with the first day of the last fiscal year. To change this date, press F9 and select a date from the box that appears. The to date displays the current date. You may change the to date to any valid date in the current fiscal year. The purpose of this report is to analyze sales according to your fiscal years, comparing this fiscal year to last fiscal year. Therefore the from date must be the first day of a fiscal year. When you change the from date, the to date must be within the following fiscal year of the from date.
F7 - Continue	Continue to next screen, unless screen is not completed correctly.

The second page of the Ten-Way Sales Report parameters is shown below.

It includes additional Include/Omit options, followed by several miscellaneous options.

Parameter	Description
Include Trim	Enter Y or N. Controls whether or not items that contain a trim class are included on the report.
Use Invoice, Standard, or House Costs?	Enter IC, SC, or HC, which represent the cost that will be used to calculate gross profit. The default is to use invoice costs.
Include Sales Allowances?	Enter Y to include sales allowances that are part of the total unit price. The default is Y.
Include Cost Allowances?	Enter Y to include cost allowances (rebates) as part of the unit cost. The default is Y.
Include Funds?	Enter Y to include funds (overbills) as part of the unit price. The default is N.
Include Only Sales within the GP% Span	You can limit the report to only include lines with a specified range of gross profit percentages.
Print GP% on Report?	Enter Y to show the GP% column of the report. The default is Y.

The following screen is the third page of the Ten-Way Sales Report Parameters Screen. You can enter up to 10 sort options by entering 1 - 10 next to the fields of your choice. Each sort field represents a level of sub-totaling. You must enter at least two selections by entering 1 or 2. Enter only as many as you require.

The following are examples of sort sequences you may find useful:

1) Company, 2) Sales Territory, 3) Sales Manager, 4) Salesperson, 5) Customer
1) Company, 2) Manufacturer, 3) Item Class 1, 4) Product Line, 5) Item
1) Company, 2) Salesperson, 3) Customer, 4) Cost Center, 5) Item Class 1, 6) Product Line
1) Chain, 2) Customer, 3) Manufacturer, 4) Product Line, 5) Item Number

Select sort options. Press Enter and F7.

Select one of the options. The next step is to save all of the parameters you have selected, and to enter a brief description of the report for later reference. When you use the Ten-Way Sales Analysis Report, you can recall the report parameters you have saved, and re-use them. Previously saved parameters are recalled using F2 from the first parameter screen.

Ten-Way Fill Rate Analysis Report (RSA 102)

This program generates a Fill Rate Analysis Report based on information in the Order and Invoice Files. It uses parameters common to all ten-way reports, and allows you to save your parameters for repeated use. This report analyses how well you are filling your customer orders. You can separately analyze fill rates for regularly stocked items, special order items, and non-stock items. You may define fill rate in different ways.

An order is considered filled if it is allocated or shipped. You may choose to consider lines that took a long time to ship as having not been filled. Cancelled lines will not be considered at all, and back orders are always considered unfilled. The report may be sorted in many ways, up to ten levels deep, and will show three different sets of fill rate calculations.

Line Fill % - is based on the number of lines filled divided by the number of lines ordered.
Unit Fill % - is based on the quantity filled divided by the quantity ordered.
The Average Days to Ship - shows how long, on average, it takes between the date an order is entered and the date it ships. The average days to ship is equal to the total number of days to ship divided by the total number of shipments.

You may also show the percentage of orders that are shipped within specified date spans, such as what percentage of orders ship within 7 days.

Fill rates are often very subjective. For example, some customers may monitor your fill rate on a weekly basis, others monthly, etc. Some customers use the Fill/Kill method, which means they only allow one shipment per order, with no back ordering of unshipped items. The Ten-Way Fill Rate Report gives you the flexibility to run and define fill rate reports in many different ways, so you can analyze from both your own perspective as well as those of your customers. You may also run/sort this report by manufacturer and/or products so that you can analyze your fill performance by product as well as by customer.

On the Sales Report menu (RSA), select option 102 - Ten Way Fill Rate Report. The following screen appears.

This ten-way report parameter screen is consistent with the ten-way sales analysis report. However, the Invoice Dates have been replaced with Order Dates. These fields must be filled in to run the report. This report may be run for one day, one year, etc. For example, running it for today will enable a distributor to track fill rates daily.
After selecting your first set of include/omit parameters, press Enter, then F7. Another screen appears that gives you more parameters to choose from.

The Include Trim field allows you to include or omit trim items. An item is treated as a trim piece if a valid trim class is specified in the Item Master. Enter Y to include trim items or N to omit them, a blank value in this field will include trim items in the calculations.

Press Enter to accept your input, then press F7. The Sorting Options screen appears.
This screen is used to specify the sorting sequence for the report. The fields may contain any number from 1 to 10. No number may be used twice and at least the numbers 1 and 2 have to be used. The numbers selected must be in consecutive order. The number you put in a field is the sort level that appears in the report. For example, some common and very useful sorts would be Customer by Product Line, Customer by Manufacturer, Manufacturer by Product Line, and Company by Customer. However, you can also run a very detailed analysis using all or most of the 10 sorting options, such as Company#, Salesperson, Customer, Item Class, Manufacturer, Product Line, Item#, Order/Line#.

As an example of how these sorting options work, consider the option Order/Line#. This enables you to run a very detailed analysis, showing the fill rate and days to ship of every line item. This sort option should only be specified as your last sort option, since you cannot break down order data further than line item level. Using the Order/Line field as your last sort field will be helpful when you are first learning how this report calculates fill rates. By viewing each line item, you will clearly see how each calculation has been made.

After selecting your sort options, press Enter and then F7. The Additional Parameters screen appears.

Notes about the Additional Parameters Screen

Non-Stock and Special Order are defined in the Item File. Non-Stock items are identified with an N and Special Order items are identified with an S. Stock items are identified with a Y.
You may include or omit based upon:
- Order Types - Consider eliminating credits by omitting Type C.
- Order Handling Codes - These codes enable you to zero in on a Fill/Kill or Must Ship Complete orders.
- Item ABC codes - For example, your fill rates need to be very high on A items.
You may consider filled orders as unfilled if they were not shipped within a certain number of days.
The defaults for the Days to Fill are 7 and 14 days. You can change this to meet your needs, but it cannot be left blank.
If a minimum %fill is entered, then the report will:
- omit all printed lines that have a line-%fill and a unit-%fill greater than the %fill specified.
- omit any sub-totals for which all detail lines were omitted.
- this option is used to highlight low fill rates.
Enter a ? to conduct a search of the field information for order types, handling codes, and ABC codes.

Notes about this Report

Although the unit of measure does not display, all lines are in their original unit of measure.
The Line Fill% is equal to the number of lines filled divided by the number of lines ordered (Lines Filled /Lines Ordered).
The Unit Fill% is equal to the quantity filled divided by the quantity ordered (Quantity Filled /Quantity Ordered).
An order is considered filled if it is allocated or shipped.
Canceled lines are NOT considered or included in any calculations.
Open orders, including back orders and orders that are allocated but not invoiced, are included as unfilled orders in all statistics except AvgDays to Ship and the %Shpd columns. These columns only consider lines that have been invoiced.
The AvgDays to Ship equals the total number of days to ship divided by the total number of shipments (Days to Ship/Number of Shipments).
The two %Shpd columns show what percentage of the shipped orders were shipped within a certain number of days. The defaults are 7 and 14 days. You may change these defaults.
When calculating the number of days to ship, the program will automatically adjust for the following exceptional conditions.
- If the ship date is found to be prior than the order date, it is assumed the order was shipped the same date of the order.
- If a ship date is found to be greater than 365 days from the order date, then the invoice date is tested, and if less than 365 days, is used as the ship date.
- If both the ship date and the invoice date is found to be greater than 365 days from the order date, then the number of days is set at 365. This is done in order to prevent one order from affecting the average fill too greatly. No figure greater than 365 will be used.

X by Y Sales Trend Report - RSA 201

This report is useful in performing comparative analysis over a 24 month period. It includes information from the various Master Files in the Description column.

In addition to the field values, the related descriptions of most X and Y selection fields are printed.

One version of the X by Y Sales Trend Analysis Report (for regular or credits only version) can list the number of lines rather than dollars or units. The number of lines relates to line items within invoices. This option is especially useful for the following customized reports:

Number of lines by credit type within branch, manufacturer, and so on. This report shows how many occurrences there are of each type of credit, including pricing errors, shipping errors, or claims.
Number of lines by truck route within warehouse indicating the picking and loading activity level.
Number of lines by price list number indicating how often different price lists are used.
Number of lines by restriction code for counting cuts, rolls, and so forth.
Number of lines by operator initials, salesperson, or work station ID indicating productivity levels.

In order to use the this feature, enter option L in the Show Values in Dollars, Units, or Lines field of the X by Y Sales Trends and X by Y Spreadsheet Programs.

Associated Files

Maintain X By Y Job Queues - SET 305

X by Y Ranking Reports - RSA 203

This option produces a ranking report based on one of the following: Gross Sales, Gross Profit $, Gross Profit %, and Quantity Sold.

Associated Files

Maintain X By Y Job Queues - SET 305

X By Y Spreadsheets (RSA 209)

Your X and Y parameter selections become the rows and columns on the spreadsheet. For example, if you select customer and item class, the rows (which run down the page) are customers, and the columns (which run across the page) are item classes. If you choose a category that requires more columns than can fit on a page, the system issues additional pages to contain the extra columns. The spreadsheet can include sales dollars, quantity sold, or number of lines. Using the spreadsheet option can display what is not selling, as well as what is selling. For example, a spreadsheet of customer type by item class would show which customer types do or do not buy certain item classes. This spreadsheet is accessed via option 9 on the X by Y Report Menu. When running a spreadsheet, we recommend that your Y (second) selection has fewer potential values than your X (first) selection. For example, when running a spreadsheet for item by branch, select item first, followed by branch. Branches are more likely to fit across the page. The items are the rows going down the page. This report is currently set with a limit of no more than 20,000 X values or 20,000 Y values in order to conserve system resources.

This option allows you to quickly and easily analyze sales by invoice or date range. For example, as shown below, the report can be run with Item as the X factor and manufacturer as the Y factor. This provides a quick glance as to which manufacterers are selling which products.

The X and Y report sales category selections can be changed to various combinations to customize the report.

Associated Files

Maintain X By Y Job Queues - SET 305

X By Y Manufacturer Rebates (RSA 210)

This report is designed primarily for submission to manufacturers who require this information in a printed form. The X by Y format gives you the flexibility to include, omit, and sort the data effectively. The report displays the unit and extended rebate amounts being claimed. The report includes your item number and the supplier's item number, as well as your unit of measure and the supplier's unit of measure. This report captures rebates generated from the new Manufacturer's Rebate Matrix Table, as well as rebates generated from the Promotional Pricing File. Rebates generated from the new Manufacturer's Rebate Table are identified by program number TAB#00, which is the default program number used when that table is accessed.

Manufacturer rebates can be reconciled with a the X by Y Manufacturer Rebates Report. There are three versions of this report:

Version 1 - Report To Manufacturer - is used to report sales and rebate information to manufacturers. It is not used to reconcile payments or credits from manufacturers regarding rebates.
Version 2 - Rebate Reconciliation - is used to reconcile rebates from manufacturers. It includes the rebate amount claimed, the amount paid or credited by the manufacturer, and the amount remaining open.
Version 3 - Detailed Rebate Reconciliation w/Ref # - produces the detailed version of the Rebate Reconciliation report, which shows multiple payments and adjustments per invoice or line.

If you used the Manual Rebate Reconciliation Update Program to mark rebates as paid using an X or P, those entries are shown on versions 2 and 3. They are considered paid in full.

Associated Files

Maintain X By Y Job Queues - SET 305

X by Y Shipping Quantity Analysis Reports (RSA 211)

This report is designed to reveal patterns in order quantities. These patterns can assist you in determining optimum purchasing quantities and minimum roll, shade and dye lot sizes to manufacture or stock.

The report is formatted like a Ranking Report, with the Y variable sorted in descending order by quantity sold. It is recommended that you run the report choosing warehouse, company, manufacturer or cost center as your X variable, and item as your Y variable. This will generate a report that satisfies the intended purpose of this program. You can select other X variables to analyze shipping quantities in other ways. Your Y variable should always be a product variable such as item, color or product line. By analyzing the average and median cut quantities for rolled goods, you will be able to determine optimum remnant settings. You will also be able to determine whether the roll sizes being manufactured are suited to the orders being placed. For non-rolled goods, analyzing the average, median and maximum ship quantities and the standard deviations allows you to judge remnant settings and optimum minimum purchase quantities. Your goal is to order enough of each shade/ dye lot to service the quantities you typically ship.

This report has two versions. The Rolled Goods version and the non-rolled goods version.

The columns on the rolled goods version are as follows:

Field Name	Description
Item#	The item number followed by the item description.
Quantity Sold	The quantity sold per item for the selected date span.
Rank	The rank position of the item within the group of items. A rank of 10 indicates the item had the 10th highest quantity sold in the group of items.
% of Total	The percentage of total quantity sold that each item represents.
Running%	The running total of the% of total column.
Gross Sales	The sales in dollars of each item for the selected date span.
# Lines	The number of line items sold for each item.
# Rolls/Bal	The number of full rolls and roll balances sold for this item.
%Rolls/Bal	The percentage of total lines that are full rolls or roll balances.
# Cuts	The number of cuts sold for each item.
% Cuts	The percentage of total lines that are cuts.
Avg Cut-Size	The average size of cuts for each item. Average cut size = total quantity sold as cuts /# of cuts.
Median Cut Size	The size of the median cut. The median is the middle of a list of all the cuts, in cut size sequence.
Qty-Sold Cuts	The total quantity sold as cuts for each item.
% of Qty Sold	The percentage of the total quantity sold that is represented by cuts.

The non-rolled goods version of the X by Y Shipping Quantity Analysis Report, as shown above has the following columns:

Field Name	Description
Item#	The item number followed by the item description.
Quantity Sold	The quantity sold per item for the selected date span.
Rank	The rank position of the item within the group of items. A rank of 10 indicates the item had the 10th highest quantity sold in the group of items.
% of Total	The percentage of total quantity sold that each item represents.
Running %	The running total of the % of total column.
Gross Sales	The sales in dollars of each item for the selected date span.
# Lines	The number of line items sold for each item.
#Uncut Lines	The number of lines that are not cuts. Note: cuts only apply to items that are actually cut, such as laminate countertop material.
%Uncut Lines	The percentage of lines that are not cuts.
# Cuts	The percentage of lines that are cuts. Note: cuts only apply to items that are actually cut, such as laminate countertop material.
% Cuts	The percentage of lines that are cuts.
Avg Ship Qty	The average quantity sold/shipped. Average ship quantity = total quantity sold /# of lines.
Median Ship Qty	The size of the median shipment quantity. The median is the middle of the list of all lines sold, sequenced by quantity sold.
STD DEV	Standard Deviation=The average difference between each quantity sold versus the average quantity sold. Larger standard deviations indicate less consistency in the quantities sold.
Max Ship Qty	The maximum individual quantity sold for each item.

Associated Files

Maintain X By Y Job Queues - SET 305

Profit Trends Analysis Report (RSA 212)

This report allows you to trend GP % or $ over a 12 month period.

Notes:

Display Types are three-character codes that represent major product displays and sample sets that are provided by your company or your suppliers, and used by your customers to proÂmote your products. They enable you to track which customers have which displays or samÂples, and to analyze sales for customers with and without these displays. Display types entered for each customer via F14 from the Billto File. You can code up to 20 displays per customer. Special pricing can be assigned to a display type which affects all customers assigned with that display type code.
Item Class 1 - These two-character codes represent broad classifications of items. For examÂple, use WD for wood, FT for floor tile, or VT for vinyl tile. Each item is assigned one of these codes in the Item Class 1 field in the Item Master File.
Cost Centers - A cost center defines a category of income or expenses. For instance, if you have different types of cost centers representing your inventory, you can group them together in a cost center group field called INV. Complete inventory and sales information is tracked for each cost center.
Sales Manager File - Sales manager codes are created in the Sales Manager File (FIL 35) and can be assigned to each salesperson in the Salesperson File. A sales manager represents a group of salespeople. You also can define a group of salespeople who are not literally sales managers. For example, Sales Manager B20 could represent the Boston Sales Group or the Boston sales manager.
Sales Territory - These codes represent sales territories assigned to each salesperson. A sales territory represents a geographical grouping of salespeople and is a composite view of all of the salespeople assigned to the sales territory.
Chain - These three-character codes represent chain stores and other multi-location accounts, or groups of accounts. For example, JCP for JC Penney. Chain codes are assigned to account numbers via the Chain field in the Billto File.
Policy - Three two-character codes identify special processing or identify special items. Following is an explanation of some of the system-defined policy codes:
- NR - No rebates or cost allowances.
- DI - To be discontinued
- DV - For quantity break groups, divide by the multiplier instead of multiplying
- MI - Manufactured internally
- MS - Mandatory lot number
- NB - No broken units
Transaction Types - These one-character codes define the type of transactions available to the Order Entry, Sales Analysis, and Pricing modules. These codes should be included when your system is initially installed. They include:
- C - Intercompany sales
- D - Direct shipments
- I - Sales from inventory
- M - Mill direct billing. This code is not used at this time. Use D instead.
- S - Special orders
Restrictions - Restriction codes are system-defined codes used primarily for pricing. Some examples are:
- R - Roll price (rolled goods only)
- C - Cut price (rolled goods only)
- B - Roll balance (rolled goods only). Translates to R for pricing and statistics.

Use the field Show values in $=GP$, %=GP% to choose whether to show the data in dollar amounts (enter a $) or as a percentage (enter %).

Ability to Create a Spreadsheet from the X by Y Reports

You can download the information generated from an X by Y report into an Excel spreadsheet, and you can email the spreadsheet by entering an email address.

This affects the following X by Y reports:

Sales Trends Analysis Reports
Gross Profit Analysis Reports
Ranking Reports
Comparative Analysis Reports
Performance Reports
Commission Reports

The X by Y spreadsheet includes much more information than the printed reports, enabling you to use the power of Excel to manipulate the data. For example, whenever one of your X by Y sort parameters is Item, the spreadsheet will also contain all of the classification codes associated with each item, such as Item Class, Cost Center, etc. You may then use Excel to sort by and summarize by any of the additional codes.

These X by Y reports can be accessed from either the Sales Report Menu (options RSA 201-206) or the Master Reports Menu (options RPT 381-386).

Each of the X by Y report versions take you through several screens that allow you to select parameters to include in the report. The following screens appear when requesting an X by Y report:

Parameter selection - i.e., time frame for the report, invoice range, deciding which entities (companies, cost centers, accounts, etc.) to include
Selection of X and Y fields - If the item, customer, or salesperson categories are selected as either the X or Y factor, additional data is included on the spreadsheet. The additional information is noted below:
- If Item is selected as either the X or Y fields - the spreadsheet will include the fields on the report plus cost center, prod line, class 1 & 2 & 3, trim class, color name, pattern name, item abc code, inventory flag, discontinued date (mmddyy), usual supplier, price class, and commodity level
- If Salesperson is selected as either the X or Y fields - the spreadsheet will include the fields on the report plus sales branch, sales manager, and sales territory, which are gathered from the Salesperson File.
- If Customer is selected as either the X or Y fields - the spreadsheet will include the fields on the report plus branch, state, city, zip, customer type, region code, customer abc code, chain, code, salesperson, county number, full shipto address and warehouse.
After selecting the X and Y fields, a review screen appears.

Press Enter and then F7 to continue to the next screen. This screen is where you can direct the system to generate a regular spool file and/or a spreadsheet file.

The fields on this screen are described in the following table.

Field	Description
Report Type	Option 1 generates a regular report that gets sent to your spool file where you can print it out as needed. If you choose this option, none of the other fields are required. Option 2 sends the information to a spreadsheet program. You can then choose to print it or email it. Option 3 creates both a spool file and a spreadsheet file.
The following fields are required only if you choose option 2 or 3 to generate a spreadsheet.
File Name	Enter the file name. You should attach the suffix .xls to the file name.
Destination Folder	This is the IFS directory where you want the spreadsheet to be placed. Once the spreadsheet is generated and sent to this destination you can retrieve it via the Windows Explorer, if you are mapped to the folder. It can also be accessed via WRKLNK command on the IBM iSeries. You cannot use directory /QDLS. If you do not enter a destination folder, you must enter an email address. If no destination folder is entered, a temporary one is created that is automatically deleted when the email is sent.
EMAIL File to	Enter the email addresses of the person or people you want to receive the report. To access more lines, press the Page Down key. The following guidelines pertain to the email feature: You do not have to assign a directory if you email only, the system will automatically use /home/dancik/reports/temp A Java Kit must be installed on your server (automatically installed via the IBM V5R3 Upgrade). The HTTP Server, TOMCAT and APACHE servers must be running. If you use the ODS system these servers will already be running.

If you do not want to create a directory, you can use the default directory: /home/dancik/reports/xbyy. To access the reports via Excel, you will need to Map the PC to access the files.

Security Restrictions

Many X by Y sales reports can contain sensitive cost/profit and performance information that you might not want some users to obtain. These reports have always supported customer and management versions to aid in restricting publication of sensitive information. Access to management versions for ROCS users is limited to individuals who are authorized to access cost information in the user control panel file.

To Restrict the Management Version of X by Y Sales Reports

Access the CTRLUSER record for the user you would like to restrict.
Set the Allow Costs to Show on Order Entry For This User and Adjust Costs fields to N.
If the user is restricted, when the following X by Y sales reports are accessed they can only be run in customer version.
- Gross Profit Analysis
- Comparative Analysis
- Sales Commissions
- Performance Reports
If they try to enter an M to run a management version of the report, an error message is displayed.